package com.yellowpage.ndc.data;

import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import org.hibernate.annotations.GenericGenerator;


/**
 * ProdGroup entity. @author MyEclipse Persistence Tools
 */
@Entity
@Table(name="db_ndc.PROD_GROUP")

public class ProdGroup  implements java.io.Serializable {


    // Fields    

     private Long id;
     private String prodClassCode1;
     private String prodClassName1;
     private String prodClassCode2;
     private String prodClassName2;
     private String groupId;
     private String name1;
     private String name2;
     private String subname1;
     private String subname2;
     private String subname3;
     private String subname4;
     private String tel;
     private String tel2;
     private String telExt;
     private String faxFlag;
     private Short sb;
     private Integer listOrder;
     private String regionCode;
     private String regionName;
     private String cityCode;
     private String cityName;
     private String destrictCode;
     private String destrictName;
     private String areaCode;
     private String addr;
     private String zip;
     private String pyAddr;
     private String engAddr;
     private Double poix;
     private Double poiy;
     private Double custStatus;
     private String custTypeCode;
     private Long classMainId;
     private String orgId;
     private String url;
     private String weibo;
     private String weiboName;
     private String weixin;
     private String yixin;
     private String logo;
     private String safeStatus;
     private String bxName;
     private String pyName;
     private String engName;
     private String spName;
     private Long prodClassId;
     private Date modifyTime;
     private Integer modifyEmpId;
     private Date inputTime;
     private Integer inputEmpId;


    // Constructors

    /** default constructor */
    public ProdGroup() {
    }

	/** minimal constructor */
    public ProdGroup(String prodClassName1, String prodClassName2, String groupId, String name1, String tel, Integer listOrder, String regionCode, String cityCode, String destrictCode) {
        this.prodClassName1 = prodClassName1;
        this.prodClassName2 = prodClassName2;
        this.groupId = groupId;
        this.name1 = name1;
        this.tel = tel;
        this.listOrder = listOrder;
        this.regionCode = regionCode;
        this.cityCode = cityCode;
        this.destrictCode = destrictCode;
    }
    
    /** full constructor */
    public ProdGroup(String prodClassCode1, String prodClassName1, String prodClassCode2, String prodClassName2, String groupId, String name1, String name2, String subname1, String subname2, String subname3, String subname4, String tel, String telExt, String faxFlag, Short sb, Integer listOrder, String regionCode, String regionName, String cityCode, String cityName, String destrictCode, String destrictName, String areaCode, String addr, String zip, String pyAddr, String engAddr, Double poix, Double poiy, Double custStatus, String custTypeCode, Long classMainId, String orgId, String url, String weibo, String weiboName, String weixin, String yixin, String logo, String safeStatus, String bxName, String pyName, String engName, String spName, Long prodClassId, Date modifyTime, Integer modifyEmpId, Date inputTime, Integer inputEmpId,String tel2) {
        this.prodClassCode1 = prodClassCode1;
        this.prodClassName1 = prodClassName1;
        this.prodClassCode2 = prodClassCode2;
        this.prodClassName2 = prodClassName2;
        this.groupId = groupId;
        this.name1 = name1;
        this.name2 = name2;
        this.subname1 = subname1;
        this.subname2 = subname2;
        this.subname3 = subname3;
        this.subname4 = subname4;
        this.tel = tel;
        this.telExt = telExt;
        this.faxFlag = faxFlag;
        this.sb = sb;
        this.listOrder = listOrder;
        this.regionCode = regionCode;
        this.regionName = regionName;
        this.cityCode = cityCode;
        this.cityName = cityName;
        this.destrictCode = destrictCode;
        this.destrictName = destrictName;
        this.areaCode = areaCode;
        this.addr = addr;
        this.zip = zip;
        this.pyAddr = pyAddr;
        this.engAddr = engAddr;
        this.poix = poix;
        this.poiy = poiy;
        this.custStatus = custStatus;
        this.custTypeCode = custTypeCode;
        this.classMainId = classMainId;
        this.orgId = orgId;
        this.url = url;
        this.weibo = weibo;
        this.weiboName = weiboName;
        this.weixin = weixin;
        this.yixin = yixin;
        this.logo = logo;
        this.safeStatus = safeStatus;
        this.bxName = bxName;
        this.pyName = pyName;
        this.engName = engName;
        this.spName = spName;
        this.prodClassId = prodClassId;
        this.modifyTime = modifyTime;
        this.modifyEmpId = modifyEmpId;
        this.inputTime = inputTime;
        this.inputEmpId = inputEmpId;
        this.tel2 = tel2;
    }

   
    // Property accessors
    @GenericGenerator(name="generator", strategy="identity")
    @Id 
    @GeneratedValue(generator="generator")   
    @Column(name="ID", unique=true, nullable=false)

    public Long getId() {
        return this.id;
    }
    
    public void setId(Long id) {
        this.id = id;
    }
    
    @Column(name="PROD_CLASS_CODE1", length=8)

    public String getProdClassCode1() {
        return this.prodClassCode1;
    }
    
    public void setProdClassCode1(String prodClassCode1) {
        this.prodClassCode1 = prodClassCode1;
    }
    
    @Column(name="PROD_CLASS_NAME1", nullable=false, length=256)

    public String getProdClassName1() {
        return this.prodClassName1;
    }
    
    public void setProdClassName1(String prodClassName1) {
        this.prodClassName1 = prodClassName1;
    }
    
    @Column(name="PROD_CLASS_CODE2", length=8)

    public String getProdClassCode2() {
        return this.prodClassCode2;
    }
    
    public void setProdClassCode2(String prodClassCode2) {
        this.prodClassCode2 = prodClassCode2;
    }
    
    @Column(name="PROD_CLASS_NAME2", nullable=false, length=256)

    public String getProdClassName2() {
        return this.prodClassName2;
    }
    
    public void setProdClassName2(String prodClassName2) {
        this.prodClassName2 = prodClassName2;
    }
    
    @Column(name="GROUP_ID", nullable=false, length=16)

    public String getGroupId() {
        return this.groupId;
    }
    
    public void setGroupId(String groupId) {
        this.groupId = groupId;
    }
    
    @Column(name="NAME1", nullable=false, length=192)

    public String getName1() {
        return this.name1;
    }
    
    public void setName1(String name1) {
        this.name1 = name1;
    }
    
    @Column(name="NAME2", length=128)

    public String getName2() {
        return this.name2;
    }
    
    public void setName2(String name2) {
        this.name2 = name2;
    }
    
    @Column(name="SUBNAME1", length=64)

    public String getSubname1() {
        return this.subname1;
    }
    
    public void setSubname1(String subname1) {
        this.subname1 = subname1;
    }
    
    @Column(name="SUBNAME2", length=64)

    public String getSubname2() {
        return this.subname2;
    }
    
    public void setSubname2(String subname2) {
        this.subname2 = subname2;
    }
    
    @Column(name="SUBNAME3", length=64)

    public String getSubname3() {
        return this.subname3;
    }
    
    public void setSubname3(String subname3) {
        this.subname3 = subname3;
    }
    
    @Column(name="SUBNAME4", length=64)

    public String getSubname4() {
        return this.subname4;
    }
    
    public void setSubname4(String subname4) {
        this.subname4 = subname4;
    }
    
    @Column(name="TEL", nullable=false, length=20)

    public String getTel() {
        return this.tel;
    }
    
    public void setTel(String tel) {
        this.tel = tel;
    }
    
    @Column(name="TEL_EXT", length=10)

    public String getTelExt() {
        return this.telExt;
    }
    
    public void setTelExt(String telExt) {
        this.telExt = telExt;
    }
    
    @Column(name="FAX_FLAG", length=1)

    public String getFaxFlag() {
        return this.faxFlag;
    }
    
    public void setFaxFlag(String faxFlag) {
        this.faxFlag = faxFlag;
    }
    
    @Column(name="SB", precision=4, scale=0)

    public Short getSb() {
        return this.sb;
    }
    
    public void setSb(Short sb) {
        this.sb = sb;
    }
    
    @Column(name="LIST_ORDER", nullable=false, precision=6, scale=0)

    public Integer getListOrder() {
        return this.listOrder;
    }
    
    public void setListOrder(Integer listOrder) {
        this.listOrder = listOrder;
    }
    
    @Column(name="REGION_CODE", nullable=false, length=6)

    public String getRegionCode() {
        return this.regionCode;
    }
    
    public void setRegionCode(String regionCode) {
        this.regionCode = regionCode;
    }
    
    @Column(name="REGION_NAME", length=64)

    public String getRegionName() {
        return this.regionName;
    }
    
    public void setRegionName(String regionName) {
        this.regionName = regionName;
    }
    
    @Column(name="CITY_CODE", nullable=false, length=6)

    public String getCityCode() {
        return this.cityCode;
    }
    
    public void setCityCode(String cityCode) {
        this.cityCode = cityCode;
    }
    
    @Column(name="CITY_NAME", length=64)

    public String getCityName() {
        return this.cityName;
    }
    
    public void setCityName(String cityName) {
        this.cityName = cityName;
    }
    
    @Column(name="DESTRICT_CODE", nullable=false, length=6)

    public String getDestrictCode() {
        return this.destrictCode;
    }
    
    public void setDestrictCode(String destrictCode) {
        this.destrictCode = destrictCode;
    }
    
    @Column(name="DESTRICT_NAME", length=64)

    public String getDestrictName() {
        return this.destrictName;
    }
    
    public void setDestrictName(String destrictName) {
        this.destrictName = destrictName;
    }
    
    @Column(name="AREA_CODE", length=8)

    public String getAreaCode() {
        return this.areaCode;
    }
    
    public void setAreaCode(String areaCode) {
        this.areaCode = areaCode;
    }
    
    @Column(name="ADDR", length=256)

    public String getAddr() {
        return this.addr;
    }
    
    public void setAddr(String addr) {
        this.addr = addr;
    }
    
    @Column(name="ZIP", length=6)

    public String getZip() {
        return this.zip;
    }
    
    public void setZip(String zip) {
        this.zip = zip;
    }
    
    @Column(name="PY_ADDR", length=16)

    public String getPyAddr() {
        return this.pyAddr;
    }
    
    public void setPyAddr(String pyAddr) {
        this.pyAddr = pyAddr;
    }
    
    @Column(name="ENG_ADDR", length=128)

    public String getEngAddr() {
        return this.engAddr;
    }
    
    public void setEngAddr(String engAddr) {
        this.engAddr = engAddr;
    }
    
    @Column(name="POIX", precision=9, scale=6)

    public Double getPoix() {
        return this.poix;
    }
    
    public void setPoix(Double poix) {
        this.poix = poix;
    }
    
    @Column(name="POIY", precision=9, scale=6)

    public Double getPoiy() {
        return this.poiy;
    }
    
    public void setPoiy(Double poiy) {
        this.poiy = poiy;
    }
    
    @Column(name="CUST_STATUS", precision=2, scale=0)

    public Double getCustStatus() {
        return this.custStatus;
    }
    
    public void setCustStatus(Double custStatus) {
        this.custStatus = custStatus;
    }
    
    @Column(name="CUST_TYPE_CODE", length=1)

    public String getCustTypeCode() {
        return this.custTypeCode;
    }
    
    public void setCustTypeCode(String custTypeCode) {
        this.custTypeCode = custTypeCode;
    }
    
    @Column(name="CLASS_MAIN_ID", precision=18, scale=0)

    public Long getClassMainId() {
        return this.classMainId;
    }
    
    public void setClassMainId(Long classMainId) {
        this.classMainId = classMainId;
    }
    
    @Column(name="ORG_ID", length=40)

    public String getOrgId() {
        return this.orgId;
    }
    
    public void setOrgId(String orgId) {
        this.orgId = orgId;
    }
    
    @Column(name="URL", length=256)

    public String getUrl() {
        return this.url;
    }
    
    public void setUrl(String url) {
        this.url = url;
    }
    
    @Column(name="WEIBO", length=256)

    public String getWeibo() {
        return this.weibo;
    }
    
    public void setWeibo(String weibo) {
        this.weibo = weibo;
    }
    
    @Column(name="WEIXIN", length=256)

    public String getWeixin() {
        return this.weixin;
    }
    
    public void setWeixin(String weixin) {
        this.weixin = weixin;
    }
    
    @Column(name="YIXIN", length=256)

    public String getYixin() {
        return this.yixin;
    }
    
    public void setYixin(String yixin) {
        this.yixin = yixin;
    }
    
    @Column(name="LOGO", length=256)

    public String getLogo() {
        return this.logo;
    }
    
    public void setLogo(String logo) {
        this.logo = logo;
    }
    
    @Column(name="SAFE_STATUS", length=1)

    public String getSafeStatus() {
        return this.safeStatus;
    }
    
    public void setSafeStatus(String safeStatus) {
        this.safeStatus = safeStatus;
    }
    
    @Column(name="BX_NAME", length=256)

    public String getBxName() {
        return this.bxName;
    }
    
    public void setBxName(String bxName) {
        this.bxName = bxName;
    }
    
    @Column(name="PY_NAME", length=256)

    public String getPyName() {
        return this.pyName;
    }
    
    public void setPyName(String pyName) {
        this.pyName = pyName;
    }
    
    @Column(name="ENG_NAME", length=256)

    public String getEngName() {
        return this.engName;
    }
    
    public void setEngName(String engName) {
        this.engName = engName;
    }
    
    @Column(name="SP_NAME", length=256)

    public String getSpName() {
        return this.spName;
    }
    
    public void setSpName(String spName) {
        this.spName = spName;
    }
    
    @Column(name="PROD_CLASS_ID", precision=18, scale=0)

    public Long getProdClassId() {
        return this.prodClassId;
    }
    
    public void setProdClassId(Long prodClassId) {
        this.prodClassId = prodClassId;
    }
    @Temporal(TemporalType.TIMESTAMP)
    @Column(name="MODIFY_TIME", length=0)

    public Date getModifyTime() {
        return this.modifyTime;
    }
    
    public void setModifyTime(Date modifyTime) {
        this.modifyTime = modifyTime;
    }
    
    @Column(name="MODIFY_EMP_ID")

    public Integer getModifyEmpId() {
        return this.modifyEmpId;
    }
    
    public void setModifyEmpId(Integer modifyEmpId) {
        this.modifyEmpId = modifyEmpId;
    }
    @Temporal(TemporalType.TIMESTAMP)
    @Column(name="INPUT_TIME", length=0)

    public Date getInputTime() {
        return this.inputTime;
    }
    
    public void setInputTime(Date inputTime) {
        this.inputTime = inputTime;
    }
    
    @Column(name="INPUT_EMP_ID")

    public Integer getInputEmpId() {
        return this.inputEmpId;
    }
    
    public void setInputEmpId(Integer inputEmpId) {
        this.inputEmpId = inputEmpId;
    }
    
    @Column(name="WEIBO_NAME")

	public String getWeiboName() {
		return this.weiboName;
	}

	public void setWeiboName(String weiboName) {
		this.weiboName = weiboName;
	}
	 @Column(name="TEL2")
	public String getTel2() {
		return tel2;
	}

	public void setTel2(String tel2) {
		this.tel2 = tel2;
	}
   








}